Sage 100

Trying to import into JC2 file and it is overriding the BLANK I am assigning to the Vendor Div field. Where do I backdoor this so it stops?

Why not 00?? Never mind. It's JC.

Are you using ""ASSIGN""? if so try using ""CALCULATED"" and in the calculation put "" "".

Calculated same as Assign. This is like the MRP file when you don't use customers... I know I've had to change the DD for that, but can't remember how.

Beth, I think this will do what you want, I took the instructions for the MRP ""fix"" and changed it for Job Cost Detail import. Please make a backup and take all necessary precautions; I don't have JC Detail import to use for testing this. 1. Open Library Master / Utilities / Data File Display and Maintenance (DFDM), and select ..\Mas90\Soa\Sy0dct.soa. Note: In Version 4.xx, open Library Master / Repair / Data File Display and Maintenance. 2. Type "" JC.DETAIL B004"" in the 'Key' field and press ENTER. The ""JC.DETAIL B004"" record displays. Note: Verify that "" JC.DETAIL B004DIVISION_NO "" displays in the first line of the record. Only the division number record should be modified. 3. Click the 'Edit' button, enter the following, and press ENTER: o Field Number = 1 o Starting Position = 31 o Length = 1 4. Change ""Z"" to ""S"" (uppercase, without quotes) in the 'Change' field. 5. Click 'Ok' button to accept the change. 6. Close DFDM. 7. Open Visual Integrator / Main / Import Job Maintenance. 8. Select any import job. The data dictionaries should automatically recompile. If they do not, close Import Job Maintenance and open Export Job Maintenance to force the recompilation there. or you can do file>run>svcmpl

@DavidOverholt - THAT's IT!

Beth, after I sent the last post I thought of a way to test (sort of). I have Master Developer tools and I used those tools to make the same change as above. I then went into DFDM to check and I confirmed that the record and field and change is all correct so that should work for you!