We have a situation where landed cost needs to be applied before PO Receipt and landed cost is paid before receipt. Landed Cost Vendor is different from the PO Vendor. Landed Cost paid is to be linked to the PO. Acumatica does not allow Landed Cost creation before PO receipt. Has anybody got an workaround?
Hi
It doesn’t appear out of the box you can attach landed cost to just a PO, it has to have a PO receipt. The receipt also has to be released.
Correct, I even tried to just put in a landed cost and you can not do that either.
Hello
We can prepay Landed Cost and then connect the Prepayment to the AP Bill for Landed cost at a later time.
Prepayment of Landed Cost: Payables → Checks & Payments
- Pay Landed Cost Vendor as usual.
- Open Payables --> Checks & Payments and select Type = Prepayment
- Enter the Reference number for the Online Payment made in step 1.
- Select the Vendor for the PO being paid.
- Enter Payment Amount.
- Save and Release the Prepayment.
- Prepayments for Landed Costs credit Cash and debit the Prepaid Account listed on GL Accounts tab of the Vendor.
Later, Receive the Goods. Enter the Landed Costs. As Landed Costs are released, the Landed Costs tab of Purchase Receipts is updated with Inventory Adjustment batch numbers and (if Create Bill was selected ON above) AP Bill Reference Numbers.
If the Landed Cost vendor has open Prepayments in Acumatica, they appear on the Applications tab of the Landed Cost AP Bill. Before releasing the Landed Cost AP Bill, ceonnect the Prepayment to the bill by entering the Payment amount of the matching Prepayment on the Bill’s Applications tab. Remove Bill from Hold and release.
Using these steps, the vendor is prepaid for the Landed Cost and the Landed Costs update the inventory appropriately, the same as when Landed Costs are not prepaid.
Thanks
However the above process does not work due to the following reasons -
- Landed cost Vendor is different than the PO Vendor
- Pre-payment is paid in full for the Landed Cost Vendor before receipt of PO items
- There is no link or reference to the PO # for the Landed Cost paid as Pre-Payment
- Since Landed Cost is paid in full there is not another Landed Cost to be entered upon PO Receipt.
Process works if the Landed cost Vendor and PO Vendor are the same or if different, it works if Landed cost is applied at the time of PO Receipt for a different Vendor.
Let me know your thoughts or if I am missing something.
Regards,
Umesh
Have you tried creating an In-Transit Warehouse (that is non-nettable) where you can receive the materials into? Once the product arrives, the warehouse receiving personnel would then perform a transfer rather than a PO receipt. This would allow you to process your landed cost prior to the physical receipt. Have you tested not releasing the PO receipt and applying the Landed cost?
You cannot add a PO receipt which is not released to a landed cost. It only accepts “Released” receipts.
Nettable or Non Nettable applies if you are using Manufacturing module. Client is not using manufacturing. Either way you cannot bypass PO receipts.
Regards,
Thanks
However the above process does not work due to the following reasons -
- Landed cost Vendor is different than the PO Vendor
- Pre-payment is paid in full for the Landed Cost Vendor before receipt of PO items
- There is no link or reference to the PO # for the Landed Cost paid as Pre-Payment
- Since Landed Cost is paid in full there is not another Landed Cost to be entered upon PO Receipt.
Process works if the Landed cost Vendor and PO Vendor are the same or if different, it works if Landed cost is applied at the time of PO Receipt for a different Vendor.
Let me know your thoughts or if I am missing something.
Regards,
Umesh
Hello Umesh,
I think the process will work even when Landed Cost Vendor is different from PO Vendor and when Landed Cost is paid in full before Receipt of items.
- Enter Prepayment in AP Checks & Payments screen to Vendor 2, the Landed Cost vendor (no Bill, no Landed Cost yet).
- Later, after goods are received, enter a Landed Cost transaction to Vendor 2. Connect the Landed Cost transaction for Vendor 2 to the original PO for vendor 1.
- From Landed Cost transaction created in step 2, Create Bill for Vendor 2. Don’t release it yet! See #4...
- On the Bill created for Landed Cost vendor in previous step 3 ^, go to the Applications tab of the Landed Cost Bill. Connect the Prepayment you made in step 1 to the Bill you made in step 3 by entering the Payment amount for the prepayment on the Bill’s Applications tab. Remove Bill from Hold and release.
Prepayment is now connected to the Landed Cost and the Landed Cost is connected to the PO Receipt.
Laura
Looks like this approach will work. I will do some testing and update you.
Regards,
Umesh
Umesh
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.