MYOB AccountRight

MYOB stays the book of record for the money. This is the agreement between the two systems: what crosses, what it is called at the other end, and how long it is allowed to be. The limits below are data — change one and everything revalidates against it.

Across to MYOB

128

invoices reconciled there

In the queue

waiting on the next push

Blocked

a rule says no

Records that would be trimmed

396

across 2 fields

MYOB will not take these

Named here, not discovered by the bookkeeper next week.

INV-10748 Blackwoods Welshpool Customer PO is 26 characters; AccountRight's Customer PO field takes 20. Rule MR-INV-PO is set to warn — shorten it or let the rule truncate.

The rule set

One row per field. Edit a limit and press Set — everything on the site revalidates.

Customer

Here	In AccountRight	Limit	Transform	If it breaches
code	Card ID DEA's customer code becomes the AccountRight Card ID. Both sides stay the same string, which is what makes a two-way match possible at all.	15	Uppercase	Block
name	Co./Last Name Long trading names get cut. The full name stays here; MYOB gets what fits.	50	Truncate	Warn
abn	A.B.N. Formatted with spaces, as the ATO writes it.	14	None	Warn
terms	Terms DEA's plain-English terms mapped onto AccountRight's payment-is-due codes.	—	Map	Warn

Item

Here	In AccountRight	Limit	Transform	If it breaches
code	Item Number The stock code. DEA's codes are well inside the limit; it is the supplier references that are not, which is why those are held separately and never sent.	30	Uppercase	Block
name	Item Name This is the one that bites. A full product description will not fit in the Item Name field, so the system keeps the real description and sends MYOB a short form.	30	Truncate	Warn
spec	Description The long description. Comfortable in AccountRight, so nothing is lost here.	255	Truncate	Warn
supplier_ref	Supplier Item Number Dots, dashes and slashes come out before this goes across — the punctuation is what caused the trouble in the first place.	30	Strip punctuation	Warn

Invoice

Here	In AccountRight	Limit	Transform	If it breaches
id	Invoice Number AccountRight's invoice number field is short. DEA's numbers carry an INV- prefix, so the prefix is dropped on the way across and put back on the way home. The number a customer sees never changes.	8	Drop prefix “INV-”	Auto-fix
po_ref	Customer PO Mine-site purchase orders are long. Anything past twenty characters is cut.	20	Truncate	Warn
salesperson	Salesperson The AccountRight Salesperson card. This field does not exist in MYOB on the web, which is why the split by person cannot be run there.	—	Map	Block
cost_centre	Job Cost centre maps onto the AccountRight Job code. Also missing from the web version, and the reason sales by product range cannot be reported today.	15	Map	Block
terms	Terms Payment terms, mapped.	—	Map	Warn
status	Paid / Balance Due comes back Payments are reconciled in MYOB against the bank feed. What comes back here is the fact of payment and the date — not the bank line itself. MYOB stays the book of record for the money.	—	None	Warn
paid_at	Date Paid comes back Sets the invoice to Paid here once the bookkeeper has reconciled it there.	—	None	Warn

Invoice line

Here	In AccountRight	Limit	Transform	If it breaches
description	Description Line descriptions, including write-in lines that have no stock code behind them.	255	Truncate	Warn
code	Item Number Blank on a write-in line, which AccountRight accepts as a miscellaneous line.	30	Uppercase	Warn

Why AccountRight, not the web

Two fields only exist in the desktop version, and they are the two the business is reported on.

Salesperson

Greg Albert, Zac Albert, Nicola Rock

Without it there is no split by person.

Cost centre → AccountRight Job

7 of them

Without it there is no split by product range.

Both are carried on every quote, job and invoice here, so the split works whether or not it is being asked of MYOB.

See sales by salesperson →

Which way each thing flows

OUT Customers, items and invoices are raised here and pushed across.

BACK Payments are reconciled in AccountRight against the bank feed. What comes back is the fact of payment and the date — the bank line itself stays in MYOB.

NEVER Supplier part numbers. They are held against the stock code here and are not MYOB's business.

What would be trimmed on the way across

Run against every record on file, right now, using the rules above. The full text always stays here — it is only what MYOB receives that is shortened.

Entity	AccountRight field	Records	Example	Becomes
Item	Item Name	395	AD-BLOW-0P75 ACI regenerative blower 0.75 kW	ACI regenerative blower 0.75 k	Trimmed
Invoice	Customer PO	1	INV-10748 RIO-TINTO-PIL-2026-004871X	RIO-TINTO-PIL-2026-0	Trimmed

Sync log

Every push and every thing that came back.

When	What	Reference	Direction	Result	Detail
09 Aug 2026, 5:05 pm	Invoice	batch	To MYOB	Synced	128 invoices across, nothing rejected.
09 Aug 2026, 9:14 am	Invoice	batch	From MYOB	Synced	Payments reconciled in AccountRight against the bank feed; receipts brought back.
07 Aug 2026, 5:12 pm	Invoice	INV-10748	To MYOB	Blocked	Customer PO is 26 characters; AccountRight's Customer PO field takes 20. Rule MR-INV-PO is set to warn — shorten it or let the rule truncate.
06 Aug 2026, 4:40 pm	Item	catalogue	To MYOB	Warning	Item Name truncated to 30 characters on 61 stock codes. Full descriptions kept here.
08 Apr 2026, 5:06 pm	Invoice	INV-10732	To MYOB	Synced	Sent as 32563
02 Mar 2026, 5:06 pm	Invoice	INV-10728	To MYOB	Synced	Sent as 39941
13 Feb 2026, 5:06 pm	Invoice	INV-10726	To MYOB	Synced	Sent as 30974
12 Jan 2026, 5:06 pm	Invoice	INV-10723	To MYOB	Synced	Sent as 35203
05 Jan 2026, 5:06 pm	Invoice	INV-10722	To MYOB	Synced	Sent as 25765
13 Oct 2025, 5:06 pm	Invoice	INV-10713	To MYOB	Synced	Sent as 26696
09 July 2024, 5:06 pm	Invoice	INV-10656	To MYOB	Synced	Sent as 23587
13 June 2024, 5:06 pm	Invoice	INV-10653	To MYOB	Synced	Sent as 21719
15 Apr 2024, 5:06 pm	Invoice	INV-10646	To MYOB	Synced	Sent as 20610
29 Aug 2023, 5:06 pm	Invoice	INV-10620	To MYOB	Synced	Sent as 26416