Results 1 to 3 of 3

Thread: Importing into Pastel - Interstore transfer batch

  1. #1
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts

    Importing into Pastel - Interstore transfer batch

    Hi Guys

    We have implemented Multi-Stores in our Pastel Partner. We purchase centrally into one store and then transfer from there to the other stores where we sell from.

    We are creating CSV files to assist with making data capturing more efficient. For some reason my Import feature in the Batch button in the Interstore transfer batch window is grey'd out. How can I activate this feature?

    Thanks and kindest regards,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

  2. #2
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Alec

    You cant import a store transfer batch. According to the sage help file, the reason is because you don't capture stores per batch line, and you cannot therefor import the store information.
    You can export a interstore batch, go to the normal batch, and import that exact file, and all the information will be there. You will have to write it as a normal inventory batch reflecting the ins and outs per store. The only pain is you can't print an interstore transfer document. You can only print the batch listing.

    There is a long work around..... but it isn't pretty.
    Pastel doesn't know whether you are working in normal inv jnl or ist mode. If you did a normal journal and closed it down, you will have an accbsj.000 file, where 000 in the user who created the batch. Rename file to accbsj.xyz. go in on that user whos batch has now disappeared and change from inv jnl to multistore jnl. Close journal screen down. rename batch file back to 000. When you process inv jnl now, it will be an interstore transfer batch, and you can print the transfer document.
    Lot of work for little result - rather write the batches as normal inventory journals with an in and an out per item.

  3. #3
    Full Member
    Join Date
    Jul 2019
    Location
    Pretoria
    Posts
    71
    Thanks
    8
    Thanked 9 Times in 9 Posts
    Lol. Kevin I had a lekker lag now. Your comment about, not being pretty is brilliant. And based on your explanation I can see why you say that.

    Alright, I am going to give the normal inventory journal a try.

    Thanks again!!

    Kindest regards,
    Alec
    Alec Candiotes (CA) SA
    Business Intelligence and Report Automation developer

    www.mybi.co.zaalec@mybi.co.za • 072 997 9553

Similar Threads

  1. Pastel Partner 11 Interstore Transfer
    By farhad in forum Accounting Forum
    Replies: 11
    Last Post: 03-Jul-17, 09:06 PM
  2. PASTEL PARTNER INTERSTORE DISCREPANCIES
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 29-Sep-15, 11:11 AM
  3. [Question] How to transfer data from one company to another in Pastel Xpress
    By steyn.annemarie@gmail.com in forum Accounting Forum
    Replies: 1
    Last Post: 20-Jul-15, 02:02 PM
  4. [Question] Importing Cashbook Payments Batch into Pastel
    By Anemari in forum Accounting Forum
    Replies: 3
    Last Post: 15-Jan-14, 04:30 PM
  5. Transfer between bank accounts in Pastel Xpress?
    By J7J in forum Accounting Forum
    Replies: 2
    Last Post: 04-Apr-13, 12:06 PM

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
  •