Results 1 to 5 of 5

Thread: Importing into pastel (multi VAT/Ledger per invoice)

  1. #1
    Email problem Dirk J G's Avatar
    Join Date
    Feb 2014
    Location
    South Africa
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclamation Importing into pastel (multi VAT/Ledger per invoice)

    At the moment we’re using the Journal import, where we are importing per batch at sales and cost of sales journals.
    This means one transaction per invoice with one VAT code and one ledger code. This works for most cases.
    But what is happening is that we generate invoices with multiple lines. And each line could differ in VAT and ledger code.

    What we can do is split it as multiple journals with the same invoice number, but when printing the statements in Pastel the invoice would show more than ones, but it must show ones per invoice on the statement.
    Or
    Is there a way importing the invoice or Credit notes itself with Header and lines?



    We are doing some extra journal imports to move and remove the values to the correct Ledger accounts after importing a single sales journal to get multiple ledgers in the correct accounts, but we can't do that with VAT?

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    Quote Originally Posted by Dirk J G View Post
    Is there a way importing the invoice or Credit notes itself with Header and lines?
    Yes, refer to my post (#4) in this thread for the CSV file layout.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Email problem Dirk J G's Avatar
    Join Date
    Feb 2014
    Location
    South Africa
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the info, it looks like something I can use, just one question, I only know the basic in pastel if I import the invoices like this, where do i add the ledger codes or am I missing it on the import layout?

  4. #4
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    In the sample CSV file that I attached to my post, I used inventory codes, not GL ledger codes.

    On the Detail lines, you will need to change the 4 to a 6 in column L (i.e. from Item Code to GL) and then insert the GL codes in column J. Don't insert the / in the GL code, e.g. 1000/000 must be captured as 1000000.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Email problem Dirk J G's Avatar
    Join Date
    Feb 2014
    Location
    South Africa
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Great thanks, did not realize the 10.code was links to 12.line type. I appreciate the confirmation. It helps a lot.

Similar Threads

  1. Pastel General Ledger importing
    By osbert in forum Accounting Forum
    Replies: 8
    Last Post: 10-Dec-15, 10:23 PM
  2. [Question] Importing General Ledger Journal into Pastel Xpress V 12
    By Stevie Mac in forum Accounting Forum
    Replies: 16
    Last Post: 26-Aug-14, 11:42 AM
  3. Replies: 3
    Last Post: 30-Aug-13, 09:01 AM
  4. [Question] pastel partner importing tax invoice from connect2field
    By monsoonirrigation in forum Accounting Forum
    Replies: 1
    Last Post: 19-Mar-13, 04:28 PM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •