Forum Discussion

CropServ's avatar
CropServ
Experienced Cover User
1 month ago

Importing multiple purchases (item layout)

Hi

Have been playing around with importing multiple purchases (using item layout and we use Items and Job Numbers for our billing).

Importing 1 transaction is fine, but when trying to import more than 1 transaction/invoice, whether it be more than 1 transaction for 1 supplier or transactions for multiple suppliers only 1 transaction is uploaded to MYOB.

Is there any way MYOB can import these records as individual purchases?

Below is an example of the Text (Tab del) file being uploaded; have changed the name for privacy purposes.

I hope it is possible to upload more than one purchase at a time.

Look forward to hearing from you.

 

Co./Last NameFirst NameDateSupplier Invoice #JobItem NumberDescriptionQuantityTax CodeJournal Memo
SmithJoe23/04/20262601202500-000301AMGAMG Travel Hours2.00GSTCapezio, Michaela\Testing
SmithJoe23/04/20262601202500-000302AMGAMG Work Hours5.00GSTCapezio, Michaela\Testing
SmithJoe23/04/20262601202500-000303GKMG Travelled240.00GSTCapezio, Michaela\Testing
SmithJoe23/04/20262601202500-000305 EAssessor Expenses200.00GSTCapezio, Michaela\Testing
SmithJoe24/04/20262602202500-000101AMGAMG Travel Hours3.00GSTCapezio, Michaela\Testing2
SmithJoe24/04/20262602202500-000102AMGAMG Work Hours2.00GSTCapezio, Michaela\Testing2
SmithJoe24/04/20262602202500-000103GKMG Travelled150.00GSTCapezio, Michaela\Testing2
SmithJoe24/04/20262602202500-000105 EAAssessor Accommodation100.00GSTCapezio, Michaela\Testing2

4 Replies

  • jenniek's avatar
    jenniek
    Ultimate Partner
    1 month ago

    Hi CropServ​ 

    When importing - you need to leave a blank line between purchase orders (and sales) to separate them out into separate purchases.

  • CropServ's avatar
    CropServ
    Experienced Cover User
    1 month ago

    Thanks Jenniek. Tried this and it brings all purchases as one transaction, no matter whether there was one supplier or mulitple.