Search results for query: *

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?

That is your issue, the new MSL files should be unzipped to the Macsql\msl folder

Patrick, Honestly I cannot remember the last time I used Creystal Runtime with VBA, so I don't really know.

I meant to post your formulas that return the 2 dollar amounts, not the interest rate. Please try again.

Please share your current formulas.

fieldname.setfocus can work but has severe limitations vs sendkeys. This thread has some interesting discussion: https://www.vbforums.com/showthread.php?874379-RESOLVED-SendKeys-replacement Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Create a parameter field, call it {?Part}. Then create a record selection formula like this: {MyPartNumberField} = {?Part} Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

7.9.340 is supported all the way through SQL 2019, all updates. Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

CU meaning? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

You are supressing rows, which is a very bad idea. Supressed rows are still part of the report and will be included in any subtotals or grand totals of the report. You need to exclude these records from your report entirely with a record selection formula. Macola and Sage 50/Sage 100...

Crystal 8.5 came out in 2001. I would try this in a much newer version of crystal. Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

So you have IMDISFIL_SQL records with a Y in the int_fg field, but there is no corresponding record in the GLTRXFIL_SQL table? Did I get that right? The reason I asked about the "Interface To G/L Journal Trx File" flag is if it was checked, it is possible it was never posted or even deleted...

The IMDISFIL_SQL is the staging table. There is a field int_fg which indicates with a Y or N if that transaction has been posted to subledger or not. In your GL setup, there is a checkbox "interface to GL Jrnl Trx file?" or words to that effect. Is this box checked or not checked? Macola and...

I have start and end times that are stored as varchar such as "0700", "1600", etc. How do I convert these to time? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html