Correction: Intra invoicing - indentify part posted intra documents &or post additional intras.

How to identify part posted or partly corrected intra invoice documents in Navision.

Issue

Intra invoices are always made in pairs.

Accounting can't complete their monthly VAT tasks due to unbalanced general ledger entries as a result of a User not fully posting the intra documents or only posting half a correction. This then leaves the purchase unbalanced with the sale & an often large numerical discrepancy in the ledgers especially where multiple ref. numbers are involved.
This happens when:

a second pair of intra's are made (due to a quantity or price revision) but only the sale (doc) is posted leaving the purchase (doc) un-posted

a request to accounting is made to credit the sale intra but no consideration given to the other half of the pair, the purchase intra

Resolution

Identify which MBP Ref. number(s) are concerned & then open each in turn & make the appropriate posting or correction as required.
Pay attention to the posting date & the current open period you're working in.

Steps

Identification:

1. Use a list provided by Accounting showing which intra documents are effected & then use those documents to gain the Ref. No.
   
2. Run report FM: Intra Invoice GL 16910/11 check in Wise Analyzer
   (found under Custom Reports)

Set the dates for the period & then refresh the report.

Expand any lines where a value is present. Ignore all zero value lines.

Note the ref. number(s) where the ref. does not balance to zero e.g. 200-193976 above.

Assess each ref. individually.

1. In the case a second pair of intra docs. have been made, firstly check that the original sale intra has not been submitted to customs & is therefore declared.
2. Next, look for an un-posted intra doc which will probably be the purchase intra & will be pre-fixed with P-ON2
3. Open it with Ctrl+F5
4. Increment the Vendor Invoice Number suffix by changing the '-1' to '-2' (or more if multiple corrections are present)
      e.g. 200-200143-1 becomes 200-200143-2
   
5. Post the intra directly whilst still in the document with Posting -> Post
   
6. Refresh the Wise Analyzer report to check the refs' intra documents net to zero (& therefore so does the General Ledger)
   

Template v0.03, MPE, 08/11/2022

• Related Articles

• Error: - Finance - Message - You have one or more documents that must be posted before you post document no. XXXX

  Error message whilst trying to post a general journal. Issue A general journal has been fully prepared with all lines ready but not immediately posted. Later, the journal posting is revisited to complete it but it will not post stating the following ...

• Correction - Message - "Validation Results, Item tracking defined for item 'XX-123' in Purchase Line accounts for more than the quantity you have entered.

  Correction of the received weight on a purchase ref. Issue A purchase ref. has been received (Use Pickup = 'off') but the weight received is incorrect & the system will not allow a new value to be entered into Expected Purchase Qty  due to a tracking ...

• Correction: Ref. - How to change a service PO, ticked to recharge & service SI is made

  How to change the quantity or value on a Service PO which has been received and is ticked to recharge and recharge SI is made. Issue A service PO was made with the recharge option ticked & accounting has made the recharge SI, however, the service PO ...

• Correction: change purchase contract number on a DL ref. when quantity is received (but not invoiced), sale is shipped, invoiced & transit has not been used

  Correction: change purchase contract number on a DL ref. when quantity is received (but not invoiced), sale is shipped, invoiced & transit has not been used. Issue A direct delivery ref. has been made & processed all the way through to the sales ...

• Ref.: - Message - Item <any item code> is not on inventory

  Problem trying to receive picked up inventory from Transit. Issue Navision function Actions -> Receive Purchase/Transfer results in an error message: Checking the General tab shows a value in Quantity Received. Checking the Receive/Ship tab shows a ...