@Tigran Shahnazaryan Thanks but its not giving us the desired result, Please refer the original screenshot once formula qty should be 6. Please find the above screenshot, it is coming 1 Item ABC have two units Sales UOM : PK Another unit: CTN SO raised by using the PK unit conversion is 15 so we need to show the qty as…

Thanks @Shorin Rio Daa-Oracle

Hi @User_Y9VMM, Thanks for your reply, yes we can access the ATP lead time from item records. Some of them are default to 90 so we have updated some items manually from item records.

Hi @Shorin Rio Daa-Oracle, Thanks for your reply, in our account advanced location config was already enabled.

Thanks Patrick Fresnosa-Oracle

Thanks Shiela Marie Villaluz-Oracle

Thanks Judith Culanding-Oracle

These vouchers was actually from legacy software, for which we have already taken the GL impact so we need only for bank reco purpose.

Thanks Shiela Marie Villaluz-Oracle & Able Wilson for your kind support.

Still the same error Honey Soe Error:

Thanks for your suggestion @Honey Soe but it is not showing the desired result for all the items. original rate in invoice in saved search it is coming

@Shiela Marie Villaluz-Oracle Thanks but it will directly post into trial balance, but client don't want any GL impact for this type of transactions.

Thanks @Able Wilson.

Thanks Shiela Marie Villaluz-Oracle

Hi Nicole Mendoza-Oracle, I understand but is there any solution to overcome this issue.

Hi Niks Blando-Oracle, Thanks for your suggestion, actually client don't want to change the rate manually because of the volume of the data. It will be really panic for the client every time to verify the rate manually and alter the same. There is an integration program also available so mainly the SO will be created from…

Thanks Tigran Shahnazaryan.

Hi Tigran Shahnazaryan, Thanks for your reply, Yes it will change obviously. Can you please advise can we unlock these many periods in NetSuite.

Hi, Actually we don't need to create any new periods, we need to open the previous close periods. Example: Fiscal year starts from 2017 now we want open/unlock this 2017 periods. Is there any limitation available in NetSuite so that we can't open this backdated fiscal year because we have to open/unlock the fiscal years as…

Hi Patrick Fresnosa-Oracle, We are using Advanced taxes. Thanks for advise, now we can access to select other available Chart of account in tax type selection.

Hi Vajrala Madhu Reddy, Yes, its working now.

Hi Vajrala Madhu Reddy, Not through scripting. Below are the wayout: 1> New custom page for debit note(invoice) 2> debit note checkbox in this page to identify the type 3> Through advanced numbering, setup the different numbering for invoice & debit note.

Hi Mauricio Solís, Thanks, got the solution. Able to configure the different document numbering also.

Hi Mauricio Solís, Thanks for your reply, as per your statement you have added a custom form under invoice and cash sale. So can it be possible to follow a different document number sequence compare to invoice and cash sales. Ex: Invoice sequence : IN2406/0001 For debit note, DN2406/0001

Hi Dominica Sevilla-Oracle, Thanks for your reply, can you please advise for multi unit how can we able to get the sale quantity, sale uom in any saved search.

Hi Vajrala Madhu Reddy, Custom Transaction Types

Hi Vajrala Madhu Reddy, Thanks for your reply, followed the same but no such option available.

Hi Vajrala Madhu Reddy, As I have mentioned above, based on the client requirement we have created a custom transaction(sales debit note) form similar to Sales invoice. After the debit note has been generated, how to receive the money against the debit note or how can we raise a credit note against the same.

Thanks Elychelle Gulen-Oracle

Thanks Elychelle Gulen-Oracle