PSI Summary Report (進出存)

[Pei4]

Use Case

Users use this report to reconcile the qty. and cost summary of inventory transactions by month, inventory and warehouse. They will check if Beginning balance (Period From) + Total OUT + Total IN + Total ADJ = Ending balance (Period To).

Spec

Beginning balance

• For both qty and cost
• Only shows the beginning balance of the starting period, other periods show 0
  • Some periods without transactions will cause errors, so fill in with 0 for now

    Transactions

    Cost

• Total OUT Cost: (COGS + AssemblyOut + Issued + TransferOut])*(-1)
• Total IN Cost: Received + AssemblyIn + TransferIn + COGSCredits
• Total ADJ Cost: Adjusted

  Qty

• Total OUT Qty: (Sales + AssemblyOut + Issued + TransferOut])*(-1)
• Total IN Qty: Received + AssemblyIn + TransferIn + CreditMemos
• Total ADJ Qty: Adjusted

  Ending balance

• For both qty and cost
• Only shows the ending balance of the ending period, other periods show 0
  • Some periods without transactions will cause errors, so fill in with 0 for now

Ref

• GI180130

[Pei4]

Adjust

• Remove [Current.FinPtdCreditMemos] from Total IN Cost
• Waiting for the reply from Acumatica support about the usage of [Current.FinPtdCreditMemos]

  Ref

• Case 001082/Main?CompanyID=Lumina&ScreenId=CR306000&CaseCD=001082)