Search results for query: *

7.9.310 We have 2 x days in a row that we are out of balance in AR and AP. Not seeing any issues with the SQL connection on either day, event logs and performance is great. Where do i begin troubleshooting this? What DB tables can i look at for issues (and what am I looking for). Did ticket...

Progression 7.9.310 We have an issue with Received not Invoiced on how to clear these out that shouldn't be on there. If we back out it appears that is just takes it out of inventory and if just mark it as history it doesn't seem to move the dollar amount (correct me if I am wrong on those two...

Progression 7.9.310 We ran a variance report of anything < .01 or > .01 prior to posting the tags from yesterday's count. The posting amount was off by a significant amount versus the variance report. We didn't see but one duplicate tag that we can account for, any thoughts on this? We are...

Macola Progression 7.9.310 Is there a limit on how many days the inventory tag count process can be open? Online I have seen 1 x day, 2 x days, and then "several" days. I thought remember hearing there was a limit because they had to be posted within a certain timeframe, not sure though. Thanks,

Macola Progression 7.9.310 There are items that are getting into the IM Transactions table (IMINVTRX_SQL) and in G/L (IMDISFIL_SQL) but they are not posting to subledger. Transaction and inventory wise the $ add up but it shows variance on the G/L. Is there a staging table for things that are...

Progression 7.9.310 what is the dist_type reference in the IMDISFIL_SQL table? Found no help in the Macola help menus. I noticed when we did a normal negative inventory trx the two accounts (credit and debit lines) had a dist_type of 1 and then 2. However when we changed it to a Receipt Trx it...

Macola Progression 7.9.310 What is the table name that holds journal entries? Thanks,

Progression 7.9.310 When you do a POP order and there is a trx against G/L, when you look at the Inventory Transaction History report it shows the account, debit and credit amount of the item going into Raw materials from WIP. What SQL table is that? I have looked in all the G/L tables I could...

Mascola Progression 7.9.310 what does are the status column meaning on that table? I see a "V" and an "R" on the table but was unable to get the meaning going through the Macola help menu.

Progression 7.9.310 We had a order that would not show up doing a Power Inquiry by PO in Macola. There was nothing at all seen as different from what we could see in SQL. However, when we opened the order in Macola and hit save (no locked errors or anything) we were then able to see it in the...

Progression 7.9.310 We are having an issue with the G/L Detail Transaction report not fully opening when we do Print to File, we need the full file (not break it up) for audit. The report is 7MB, which I know is large but PDF only shows about 1/4 of what we need for the year when doing Print to...

Sorry for delays responding to responses, my notifications were getting deleted. I have Macola Progression 7.9.310 and I am trying to find the table that shows the freight amount on the line. I see it rolled up on the header but not sure where the billing screen pulls that from when it is marked...

7.9.310 We are running the aging report and the reference match the apply-to and zero-out but they still show on the report. When we look in customer history view it shows the data correctly. Is there a file validation or something we do? We did a support ticket and they want to rebuild the...

Using Progression 7.9.310. We have a lot of old orders that need to be moved to the "L" Closed status in our active header/lines. Is there any repercussion to changing the status on the headers to "L" via SQL? Or is there a way to do this via Macola in bulk (don't want to do one-by-one, there is...

Progression 7.9.310. I have been reading and had a few questions about shipped_dt. When there is a date present on a line item, is that enough to allow it to be moved to "Shipped" status and invoiced and moved to the OELINHST table, or are there other checks that are involved? We are attempting...

Progression 7.9.310: we are troubleshooting the posting issues we have had lately and found that some items on the Item Master do not have "Default Location Set". I checked Item Maintenance in Macola for Location and Item Master and do not see a field for Default Location. Additionally, although...

Progression 7.9.310 We are using the Wisys SDK and are attempting to use the cus_item_no field on the OELIN to INSERT a unique ID. We can see it working, changing the cus_item_no via the OECUSITM maintenance app in Macola and SQL updates reflect in the Macola app as well. My question is, is...

We run Progression 7.9.310. We are seeing issues with Posting sales orders where it will quit halfway through and then we have to backout and manually fix everything to ensure we are in balance for A/R (2 x times in the last two weeks and 6-7 times the past year). This is happening on multiple...

I am using Progressive 7.9.310 and we are trying to add user_def_fld_5 to the page 2 of the OE form and allow it to be edited (for automation and reporting purposes). I have successfully added it to the form and have selected every option I could find but each time it shows that it cannot be...

I am looking to improve our Warranty processes in Macola. For those that also deal in warranties, are there any "best practices" for warranty/claim/return processes and how they handle these in Macola? We are using the user_def and cmt_ fields extensively in several tables to separate orders...