Results 1 to 2 of 2

Thread: Quantities into Excel from Sage Pastel 17

  1. #1
    New Member
    Join Date
    Jun 2020
    Location
    Thabazimbi
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quantities into Excel from Sage Pastel 17

    Good day

    I linked our database in pastel with Excel but I cant seem to get it to display the inventory quantity on hand. I made a odbc link and can query all other information as far as I know. Any help would be great!

    Thanks in advance

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Nothing pretty about that formula.
    You need to access the multistoretrn table.
    Add openingqty plus qtybuythis01-13 less qtysellthis01-13 add qtyadjustthis01-13 add qtybuylast add qtyadjustlast less qtyselllast together to get qty on hand, per storecode.
    If you also want to take the unposted quantities into account, or reflect qty on sales and purchase orders - link the unposted file to your query

Similar Threads

  1. [Question] Pastel Partner - How to clear quantities on service items
    By Athol in forum Accounting Forum
    Replies: 2
    Last Post: 13-Sep-19, 08:06 AM
  2. Recover Deleted Pastel Sever-Sage Pastel
    By Danford Mavhunga in forum Accounting Forum
    Replies: 1
    Last Post: 09-Jun-17, 02:42 AM
  3. [Question] Sage One Pastel
    By StephanieB in forum Accounting Forum
    Replies: 0
    Last Post: 10-Mar-15, 01:42 PM
  4. Exporting from Pastel V12 to excel
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Feb-14, 08:26 AM

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
  •