How to enable Three Way Match: Navigate to the Settings page and toggle Three Way Match flag and click Save, the system will automatically import Receipts and Returns from Acumatica:






In MYOB Acumatica, there are two primary methods to receipt goods against a Purchase Order (PO), especially when dealing with partial deliveries:


Option 1: Single Receipt with Multiple Lines


For a single PO and PO line, MYOB Acumatica allows creating a single receipt with more than one line. Here’s how it works:

  1. Create a Single Receipt:
    • When you receive a partial delivery, you can create a single receipt for the PO.
    • Add multiple Receipt lines for the same PO line to reflect the partial deliveries.
    • For example, if the PO line ordered 7 items and you receive them in two boxes of 2 and 5 items each, you can create one receipt and split the PO line into two lines.


 

 

Option 2: Multiple Receipts


Alternatively, you can create multiple receipts for the same PO line to account for partial deliveries:

  1. Create Multiple Receipts:
    • Each time you receive a part of the order, you create a new receipt.
    • For the same scenario where the PO line ordered 7 items and you receive two boxes of 2 items and 5 items, you create two separate receipts, each with a line of 2 and 5.


Subsequent Returns


The complexity increases with returns:

  • Single Receipt with Multiple Lines:
    • If you need to return items, you can select the specific lines within the single receipt.
    • This method allows you to manage returns more granularly but might require careful tracking of which line each return is associated with.
  • Multiple Receipts:
    • Returns are straightforward as each receipt reflects a distinct delivery.
    • You can process returns against the specific receipt, making it easier to track which items from which delivery are being returned.

After receiving all inwards goods, the next step involves processing the supplier's invoice. Typically, this invoice will feature a single line for the entire quantity ordered, such as 7 items. To ensure accurate matching against the Purchase Order (PO) and PO Receipt lines, MYOB Acumatica requires splitting this single invoice line. Here's how to do it:


1. Split the Invoice Line:

 

To match each invoice line individually against the PO and PO Receipt lines, you need to split the single invoice line into multiple lines.


 



    • For instance, if the 7 items were received in two shipments of 2 and 5 items, split the invoice line into two lines.


2. Match Invoice Lines to PO Receipt Lines:

  • Ensure each split invoice line is matched to the corresponding PO receipt line. This allows for accurate tracking and reconciliation of received goods against the invoice. 



 

Example Scenario

  • Initial Setup:
    • PO Line: Ordered 7 items.
    • Receipt 1: Received 2 items.
    • Receipt 2: Received 5 items.
  • Invoice Processing:
    • Supplier Invoice: Single line for 7 items.
    • Splitting Invoice: Split into two lines of 2 and 5 items each.
    • Matching:
      • Invoice Line 1 (2 items): Match with Receipt 1.
      • Invoice Line 2 (5 items): Match with Receipt 2.


Benefits of Splitting Invoice Lines

  1. Accurate Matching:
    • Ensures that each invoice line is accurately matched to the corresponding PO and receipt lines, facilitating better tracking and reconciliation.
  2. Clear Audit Trail:
    • Provides a clear audit trail for each shipment and corresponding invoice, which is essential for accurate financial records and audits.
  3. Simplified Returns Management:
    • If returns are necessary, having split lines makes it easier to manage and track which specific shipments are being returned.

Handling Returns

Initial Purchase and Receipt

  1. Purchase Order (PO):

    • Ordered: 7 notepads.

  2. Receipts:

    • Receipt 1: 3 notepads.
    • Receipt 2: 4 notepads.

Handling Return Items

i.e. Upon receiving the first batch of 3 notepads, the company identified that these items were faulty and agreed with the supplier to return them.

Supplier Invoices and Credit Note

  1. Supplier Invoice:

    • Single line for 7 notepads.

  2. Credit Note:

    • Issued for the 3 faulty notepads.


Processing in MYOB Acumatica

Option 1: Single Receipt with Multiple Lines

  • Creating Receipts:

    • Create a single receipt with two lines:
      • Line 1: 3 notepads (Receipt 1).
      • Line 2: 4 notepads (Receipt 2).

  • Splitting the Invoice:

    • Split the single invoice line into two lines:
      • Invoice Line 1: 3 notepads.
      • Invoice Line 2: 4 notepads.

  • Matching Invoice Lines to Receipt Lines:

    • Match Invoice Line 1 with Receipt Line 1.
    • Match Invoice Line 2 with Receipt Line 2.

  • Processing the Return:

    • Select the line within the single receipt associated with the 3 faulty notepads.
    • Process the return for these 3 notepads.


Option 2: Multiple Receipts

  1. Creating Multiple Receipts:

    • Receipt 1: 3 notepads.
    • Receipt 2: 4 notepads.

  2. Splitting the Invoice:

    • Split the single invoice line into two lines:
      • Invoice Line 1: 3 notepads.
      • Invoice Line 2: 4 notepads.

  3. Matching Invoice Lines to Receipt Lines:

    • Match Invoice Line 1 with Receipt 1.
    • Match Invoice Line 2 with Receipt 2.

  4. Processing the Return:

    • Process the return directly against Receipt 1 for the 3 faulty notepads.

Finalizing the Process

  1. Credit Note:

    • Apply the credit note issued by the supplier to the invoice.
    • Ensure the credit note covers the 3 returned notepads.

  2. Reconciliation:

    • Verify that the returned items are correctly deducted from the inventory.