Building a landed cost variance report

This page is for MYOB Acumatica consultants

Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.

This knowledge base discusses how to build a report that explains what purchase receipts are responsible for postings to the land cost variance account.

Below are the 3 tables to use as a starting point.

Image

Below is the joins used.

Image Image

The conditions required - note only one COGS account is used on the transaction in this example, if you have more than one COGS account then use the condition is not NULL.

Image

Select the results grid.

Image

Now your landed costs variance report will report back all those receipts that impacted the landed cost variance account.

Image