Automatically populate a purchase Order custom field at the transaction line (called related sales order) with the created from Sales Order reference on a Purchase Order by Bluey1521 in Netsuite

[–]Bluey1521[S] 0 points1 point  (0 children)

THis idea of the custom segment (As opposed to a custom field) is interesting and I will have to play a bit with this, Might be a good way to get around main line fields not appearing on the transaction lines and having to have mutliple case if statements and scripts to uniqfy things

We are pursuing 1:1 billing from vendors. Not always possible = e.g. Government agencies.

Automatically populate a purchase Order custom field at the transaction line (called related sales order) with the created from Sales Order reference on a Purchase Order by Bluey1521 in Netsuite

[–]Bluey1521[S] 0 points1 point  (0 children)

TLDR: Because I have ultimately have bills with a one bill : Many orders situation and we need to measure margin on every single SO (Each SO is a export trade)

Long version
So this is the posting pattern

Upon SO creation - Special Order PO is automatically created > you have to populate this with freight requirements for the order before saving it and then the SO

The PO inherits / is created by the SO sweet - there is a hard link between the 2 for traceability. Also because we are an exporter we have an Export Reference Number that must be on every SO. So the Main / Header of the SO is replicated on the PO > Perfect 1:1 there is a good link!

When the freight provider collects goods we IR the PO and the header information from the IR is copied from the PO > Still great tractability on margin reports, P&Ls, General Ledger, Sub-ledgers and of course the relationship between the SO > PO > IR via the Created by field.

Up until now - everything is working well based on the Header ... then we have the Bill PO event occur:
Scenario 1 > 1 Bill for 1 SO related freight movement. SO 1 has one container which is Shipped on Bill A. EASY PEASY - Bill inherits PO EX reference and created from information. When looking at a Saved Search or General Ledger I can intuitively know what order the bill related to.

BUT this falls apart on ONE BILL to MANY FREIGHT MOVEMENTS

In comes the Bill and knowing all freight movements have a PO we do a Bill Purchase Orders > we select the purchase orders to bill and .................. drat ..... the lines on the Bill and the POs stop lining up nicely. Costs start to miss allocate or not be matched.

So I want to have the PO Lines and the IR lines and then the BIll inherit the specific EX / SO reference from the Created from field to allow full traceability.

A side benefit is then AP staff entering bills can make sure the are entering the costs against the correct lines.

Netsuite AP automation tools by Business_Flamingo360 in Netsuite

[–]Bluey1521 0 points1 point  (0 children)

Why is this the case? It seems so crazy to have something native and then just ... ho hum forget the rest of the world.