Search results for query: *

Ok please clarify: >We are having an issue where the overall parent number of the Prod Order is randomly being added as 2 in the IMINVTRX table. So are you saying the ord_no is 2? If not please elaborate. > The money isn't right, it just takes the overall cost of the parent number and moves...

There is no iminvtrx_sql.bld_qty field in Macola. In fact there is no filed called bld_qty anywhere in the Macola database. Run this SQL to find everywhere a given field name appears, You won;t find "bld_qty". SELECT sysobjects.name, syscolumns.colid, syscolumns.name, systypes.name...

Rich, You can run any Macola report and many processes on a schedule at 3am while everyone is asleep if you want to. This includes reset allocations and reset qty on order. It is called deferred processing and it has been there ever since Progression came out in 1997. Give me a shout if you...

First off, the items must have controlled flag checked at the item master level in order for Macola to maintain a Qty Allocated or a Qty on Order. Secondly, reset qty on order does nothing except print a report unless you have the "reset Inventory Trx" checkbox selected. On the receiving side...

There is no limit except your SQL Server Database size. That said, why on earth are you adding 200k items?

What version of Macola? Progression, ES or Macola 10? And what specific release? Examples: Progression 7.9.340 or Macola 10 9.8.500.

The other thing I would do is run file validation reports in Macola and fix EVERY error. Are you familiar with these reports?

OK Can you recreate this issue in a test company?

I have a couple of crystal reports that will find where - as in what transaction(s) - the out of balance took place, but it will not really troubleshoot it much beyond that point. Have you gotten this far at least?

he/she said 7.9.310

You are seriously out of balance with both? As in you post from subledger and it will not let you because the entry is out of balance? If not, please explain.

SQL 2000? Are you serious? If you upgrade to a newer version of SQL I can help you. Please, please tell me you are not running SQL 2000.

Do you have a record or group selection formula? If se comment them out ans see if it returns records.

Sorry for the late reply. What I described will not correct inventory. Presumably these vouchers debited inventory, as did the PO receipt itself. So the correcting entry, assuming no purchase price variance, is debit accrued receipts and credit inventory. You may also have fixed asset...

Sorry for the later reply. Is this something you can reproduce?

This happens when the AP voucher is entered without using the PO and Receiver. You should look at the "Force use of Receiver" checkbox in AP Setup or this issue will perpetuate itself. But in order to clean up existing invalid data on the Received Not Invoiced report, you need to update the...

Can you elaborate on exactly what a duplicate tag means? Do you literally mean the same tag number more than once? I am facing a similar dilemma right now and we do not know what is causing this.

No limit, but you can only have 1 batch per location at a time. If you haven't already, I'd suggest that you to read up on the freeze inventory process and how it works with Macola

Progression, ES or Macola 10? You should never ask a question without providing this info. Also, you should state your specific version for example Progression 7.9.340. That said, for Progression, look in OE Setup->additional OE Setup and make sure the checkbox "default qty to ship = qty...

In your main report, assuming you have groups, do you repeat the group header at the top of each page?