CAPITAL Office Business Software

Hi

Do you have any standard reports available that can be used to chase supplier overdue orders?

Repport 308 is close, but it doesn't show the Suppliers Part number.

I attempted creating one using the wizard but I failed miserably. Couldn't find a wizard that linked to the STALTPC.DBF database and had a heap of trouble trying to link to it myself in the form body.

If you don't have a standard form available could you please give me a clue how to link to the STALTPC.DBF in the form body, or is there another way? I noticed that purchase orders themselves link to a field called SUPPCODE which is supposedly a Purchase Order Items Field, but it looks like purchase order items are kept in SOSTOCK.DBF and it doesn't contain SUPPCODE.

I then searched the DATA_DICTIONARY and couldn't find SUPPCODE anywhere.

Or can you suggest a better way of chasing overdue orders?

Using the Report Wizard, "Purchase Orders Pending" would probably be the one you require.

Sostock->Delivery = expected delivery date
Sostock->Qty = quantity ordered
Stostock->Qtyd = quantity delivered

So you need to check:

Val(Sotock->Qty) > Val(Sostock->Qtyd)

for all undelivered items.

Also confirm that the order has not been closed or cancelled by checking for the status:

Sorders->Status = (status code)

The product code is Stock->Name

Are you querying STALTPC because you want to display your supplier's product code and not the system default code? (If so, you need to know a little bit more about the structure of that table, which we can help you with.)

Hi

Yes it's so we can show the supplier their own product code. I have the structure of the table but the indexes are all multiple field indexes and I'm not sure how to set them all up in the form body properties.

Regards
Barry

Two things you need to add to your report:

1. On the Links tab on the body properties section of the report add under:

Database + Key

STALTPC->TYPE

Then under:

Joined

#

Save this link addition and then add this formula to your 'supplier product code' column:

STALTPC->(Find("S" + Sorders->Socode + Stock->Name))
Return STALTPC->Altcode

Remember that next to "Code" you need to enter a variable name such as "SUPCODE" in order to change a field column into a formula column.

Yep, that works. Thanks.