Still stuck on "Confirmed PO Delivery" and "Confirmed PO Receipt", something isn't adding up.

jcarbo

I'm honestly not sure what to say about this one because I thought I had nailed down all the formulas, and then the corrected formulas, but here we are. I think I can narrow down where the errors are taking place, I just don't know how to correct them. In all truth, I could really use a review of all the formulas in blueprint view for INV01, but any help at all is appreciated. Here are the screenshots:

Please let me know if any additional information is necessary. I would just like to know which formulas need attention and how to move forward.

Prajjwal88

Hi @jcarbo ,

After reviewing your blueprint view and all the formulas you've implemented, I noticed that the issue lies in the formula used for the "Final Shipment Amount" line item.

Currently, you’ve applied a NOT condition along with the IF statement, which is causing incorrect outputs. The corrected formula should be:
IF Submit Purchase Order Request?
THEN
IF Override Suggested Order Amount? THEN
Override Amount
ELSE
Suggested Order Amount for the Month
ELSE
0
As You need to get the Suggested Order amount or the override Amount when you're submitting the Purchase order so hence you must not include that NOT in the formula.

Also for Line Item- Confirmed PO Receipt as the Post function will push the value of Final Shipment Amount for Final Shipping Time Weeks, so you must not use Negative - sign on the Final Shipping Time Weeks.

Hope this helps.😀

jcarbo

Fantastic answer. I appreciate you providing me with the correct formula for the line item. All is fixed!