Please help. When I look into the Display Sales Invoices screen, there is a outstanding balance for a customer, but this amount doesn't show on the Display Customers Invoice Balance screen, how can I fix this, please help.

ss

I'm not sure from your post if there is nothing showing on the Display customer invoice balance session, or the amount is wrong. If it is wrong use this.
Correction programs for Supplier/Customer Invoice Balances:

The correction programs can only be run from the Baan Main Menu thru File/Run Program option.
Type in otfcor0261 to correct Customer Invoice Balances.
Type in otfcor0260 for Supplier Invoice Balances.
The sessions run in ASCII . You can run for one or for a range. Answer YES to the 'Print Only ' field if you want to verify the changes before Baan actually modifies the tables! This works if you are recalculating only a few or one at a time.

BE Careful!!!! The only way to exit without processing is to recalculate for one or to click the x at the top right.

regards,
BB

Thanks for replying. First of all, I don't think we have that session, we are using BaaN 4c4. To answer your question, in the Display Sales Invoices screen it shows that there is an outstanding invoice with 3000 balance. But on the Display Customers session, it is showing 0 on the Invoice Balance.

Thank You!

ss

We run Baan4c3 and the session is there. It's just not on the menu structure.

Do This:

At Baan Main Menu click the File pull down menu at the top left.
select Run Program
You will get a screen asking for the program name and program argument.
type in the customer correction program and leave the argument blank. click continue.
Hope this helps.

BB

Thanks, Baanboozeled. Do you happen to have any documents regarding to this session?

Thanks,
ss

No, I don't have any documentation. There may be some on the baan support web but, I don't think so.

BB

Baanboozeled, if you open that session using the pull down menu and decide not to run it by clicking the "X" on the upper right hand corner, it won't start running right? (Dumb question)


ss

ss,

As far as I know.. clicking the X exits the screen and does not run the correction program.

cheers,
BB:D

Thanks, Baanboozeled. Do you know beside the session you mentioned above, what other ways can update table tccom011 (Maintain Customer Balance By Company?)

ss

It can be answered by going into the tools folder from the baan menu.
Navigation path is
baan main/ Baan IV tools/ Application Customization/ Domains and Tables/ Reports/ Print Where used Tables. This session will give you a report where the tccom011 table is used throughout baan application. fill in the screen with the table name and filed name (buin = invoice bal).
The report will take a long time to finish as it really does look through all baan sessions to see where the table is used. It is quite helpful when you really want to know.
cheers,
bb

I have a hard copy document headed "Correction Programs FINANCE". The descriptions are sketchy and I don't know if it was an official Baan document (or if it came from one). It looks like something that Baan would have produced but it doesn't have a header/footer, logo or document name.

I received it several years ago. Unfortunately, I can't find the soft copy, so I've retyped what it says about the supplier and customer balance correction programs:

tfcor260 Correction tfacp200/tccom020

This program reads the open item table and recalculates the balance amount (tccom020.buin) for the open item table and the total invoice balance in the supplier table

Tables which are updated:
tccom020 Suppliers
tfacp200 Open Items (Purchase Invoices & Receipts)

tfcor261 Correction tfacr200/tccom010

This program reads the open item table and recalculates the balance amount (tccom010.buin) for the open item table and the total invoice balance in the customer table

Tables which are updated:
tccom010 Customers
tfacr200 Open Items (Sales Invoices & Receipts)


Hope this helps. (Just remember it is from an OLD document without pedigree.)

Scott

Thank you very much....everyone are so nice in this forum.

In later versions of Baan there are session on the baan menu that you can use tfacr2245m000 and tfacp2245m000.

It can also be installed on earlier Baan versions by downloading the relevant solution and then patching it in.

We run these sessions on 4c3.

Regards
Neal Matthews
Intier Automotive - IT Support Analyst

Hi ss,

It is very easy to use the sessions in 4c4. For both customers and suppliers, the recalculate sessions appear under the Open Entries - Maintenance folders for their respective modules.

These are easier to work with than the ASCI formats from earlier BaaN versions.

Best regards,
Linda

Thank you all!!!!!:)