On occasions a Purchase Invoice will not post across to MYOB, however the Financial Posting Status is flagged as 'Transaction Valid'. The main reason for this is to do with the capabilities of the MYOB ODBC driver.

The driver software only allows the Link program to check some fields in MYOB to determine if the Suppliers Bill already exists. These fields are:

MYOB Purchase Order Number

Invoice Date

Supplier

Because we are unable to specifically check the Suppliers Invoice Number we must check these three fields in MYOB against the following in the Ostendo Purchase Invoice transaction:

MYOB Purchase Order Number -> Ostendo Purchase Invoice 'Batch Number' (NB: This is not the Financial Batch #)

MYOB Invoice Date -> Ostendo Purchase Invoice Date

MYOB Supplier -> Ostendo Purchase Invoice Supplier

If there is a match in all three fields, the link program has to assume the transaction already exists in MYOB, therefore it does not post it and must flag it as a Valid posting.

Because of MYOB's Auto Numbering system, any manually entered invoices into MYOB will use the next MYOB PO #. This PO # might well be the same as a Purchase Invoice Batch Number coming from Ostendo. 

Our suggestion for any MYOB manually entered Purchase Invoices is to always prefix the MYOB PO Number (that is self generated in MYOB) with a letter. This will mean there will never be a match of the MYOB PO number Vs the Ostendo Purchase Invoice Batch Number.

If you have a situation where invoices have not posted to MYOB you must check the following in MYOB to determine if the above has occurred.

Go to 'Find Transactions' in MYOB

Select the 'Bill' Tab and select the Search by 'PO#' option

In the  search field enter the Ostendo 'Purchase Invoice Batch Number' (NB: This is NOT the Financial Batch Number)

When you tab away from this search box, MYOB will display transactions that match this. These transactions would have been entered manually and possibly have nothing to do with the Ostendo Invoice, however they are the transactions that are causing the Invoice not to be posted across to MYOB.

Drill down into the transaction and change the 'Purchase Order Number' (maybe put a letter prefix on it).

You can tell the transaction was entered manually because all Invoices coming from Ostendo have the Supplier Name followed by the Ostendo Purchase Invoice Batch Number in the Journal Memo field of the transaction eg: ABC Industries Ltd - 4355 (where 4355 is the Ostendo Invoice Batch Number) whereas manually entered transactions in MYOB default to Purchase; ABC Industries

Then re-post the Financial Batch containing the Purchase Invoice again to MYOB and check to see it has posted correctly this time.