Forum Discussion

CropServ's avatar
CropServ
Experienced Cover User
10 days 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
    10 days 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
    10 days ago

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

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Level up your skills using MYOB software.

 

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.