Search results for query: *

Hey There, Using Macola ED 9.7.2, my customer entered a credit memo through Order Entry to correct a G/L discrepancy.....long story short, there's nothing to match it with so it drops of the aging report. Any ideas how I might get this off the aging analysis and not undo what was done to fix...

I'm in a position of differing opinion on Macola Progression 7.7.4.... 1. Extra tags? Can I have the same item_no on multiple tags, ie. item 02001 tag 400 - count qty = 40, tag 409 count quantity = 60 and it will tally it up to 100 total? 2. If I zero out all the originally created tag...

Progression 7.7.4 I have a closed year that we would like to post an adjusting one-sided entry to change our BBF, I'm probably taking a shot in the dark here I realize, but anyone ever done it without restoring from backup? Thx in advance

Hi there, Progression 7.7.4 Someone voided a couple cheques that were applied to a few invoices. In one instance the cheque was applied to a number of invoices, but the logic was for some reason they only wanted to void against 1 invoice. I edited the APINTRFACE batch to get rid of the...

Good day, I've been experimenting with backordering OE orders to push production orders. We have a co-manufacturer that releases a PO to us to produce items (We use Macola POP) and once production is complete, at a later time, they will be issuing us a second PO to ship the finished goods. It...

Good afternoon, I was curious about this feature in OE Setup. This is turned off in a new installation of Macola which we have been using since March. We want to turn it on. (Progression 7.7.8) If we do so, is there any way we can get this information into the G/L for the past periods that...

Do I need to rebuild like in Pervasive? Also, I used to simply initilise OEHDRAUD and OELINAUD? Still doable? THX in advance!

Item No10 Units Component 1 Qty per par Component 2 Qty per par Component 3 Qty per par I realize this may not work, I've looked at IMORDHST etc and It only contains OE transactions that drive Production, not 'normal' transactions per say. Thx in advance Ivan

Anyone know off-hand what the nature of these two tables relationship is? When you report production, which gets updated first? I noticed that when production is reported in POP that the pop-up is in fact an IM form - it gives you the opportunity to enter the MFG Ser Lot code there. Doesn't...

Hello, I was hopeful someone could help me with this. When I report production, I have users enter the manufacturer's lot code. I would like to launch a Crystal report that contains the manufacturer's lot code field (amongst other things). I imagine this is an on save event? Would I be...

Hello again, We did year end and either forgot or did not change to the correct period before clearing IM accumulators from OE, therefore, the YTD accumulators did not clear out. We have since closed out period 1. I realize this is sticky, but what are our options? Our year end was Feb...

Hello, I have an interesting issue - we are lotted and someone received against a PO, but accidentally put the dollars amount at zero. Tried to enter a negative transaction for the amount, but am receiving a message that the quantity has not been fully distributed. How can I get out of this...

We have sales reps across the country, and they each have their own Site ID for inventory. When they are entering orders from the Business portal, it is my understanding that any orders they enter will use the default Site ID for our head office. Is there any way to get these orders to take...

Hello, I am getting an EDI-0130 error - Invalid Conditional Relationship Segment N1 Seq 6 Element 3 I'm not really great at reading/parsing EDI stuff. The EDI code is as follows: N1*ST*CUSTOMER NAME*9*200768769876~ N1*BT*CUSTOMER NAME*9*200768760000~ N1*SU*MYCOMPANY*9~ I'm having trouble...

Hi, Possibly a very silly question. I have report that I want to run to see which customers bought one product ID number, but who also did not by another specific product number. The field for the product number is called Item_No. How would I go about it? Thx in advance!

Hi, I'm in the midst of upgrading to 7.7.100, so naturally I have been entering test orders. I have noticed that my tax schedules, which consist of 3 tax detail codes, are not getting inserted into the SYTAXLIN_SQL table. When I enter an order in my old system, all 3 detail code records do...

Hi, I want to do a setparam/requery but I seem to be going in circles with the syntax. I have a string variable called LIN_TAX_CODE that I want to feed into a query called StmtHdl3 as criteria. I seem to be running into difficult with type mismatches. I have Stmthdl3.setparam LIN_TAX_CODE, 1...

Hi, I have an old ERS script that I am converting to VBA. In the old scripts, there are two functions: ERSSQLStmtPrep and ERSSQLExecPrep What would be their equivalent in VBA? Thanks in advance for any help. Regards, Ivan

Hi there, Just updated to Progression 7.7 on MS SQL, and I am noticing that all of the pricing info has been migrated into just the table OEPRCFIL_SQL. The only logical field of reference that I can see if I wanted to combine two tables in a query is OEPRCFIL_SQL.Filler_0001, if I were to say...

Hi, Quick question - does anyone know if Macola ES is capable of sales distribution reports - I.e. how many points of presence our products are currently in, and whether there are distribution gaps - for example, if we have 2000 7-Elevens in our system, we only have product in 1000, therefore...