Disabling the standard functionality for billing the purchase orders before you receive them

We can disable the standard functionality for billing the purchase orders before you receive them.For accomplishing this we have to uncheck a feature.Go to, Setup>Accounting>Accounting PreferencesUnder Order Management, Receiving>Uncheck Bill in advance of receipt After disable this feature NetSuite itself won’t allow as to bill purchase orders before receiving them.

Close Partially Received Purchase Order with related Inbound Shipment

Requirement – Some items will be inactivated and created new corresponding Items. These inactivated items need to be changed to new ones in open transactions. Purchase orders with partially received status and Inbound shipments, can not be edited. Solution – Edit the item quantity to the received quantity in Inbound shipment. Edit the item quantity… Continue reading Close Partially Received Purchase Order with related Inbound Shipment

Calculating Minimum Purchase Quantity(MPQ) For Single Item Receipt.

Let us assume we are creating IR from PO’s: So, PO Quantity=100 MPQ=13 so now, So PO (Quantity/MPQ) = Temporary Quantity Now we will use Math.ceil(Temporary Quantity)=> Some Multiple So MPQ x Some Multiple = Required quantity to be Received. For example:- Let PO Quantity = 100, MPQ = 13 Now, By our formula =>… Continue reading Calculating Minimum Purchase Quantity(MPQ) For Single Item Receipt.

Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.

Steps:- First visit a Parent PO record. Click on edit and enter a desired positive integer value in the Number of Recurrence field. Click on save. Make a copy of the Parent PO. Save the child record or copy of that PO. Navigate to the respective or related Parent PO. The number will be reduced… Continue reading Reducing the Recurrence count by one whenever a user creates a copy of the PO record in Before Submit Trigger using User Event Script in Netsuite.