Sage 100

I would swear I've done that before.  I don't see why it would NOT work...

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

Checking... stand by.

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

Allow Profit Margin Percent Override During S/O Data Entries is enabled.

Checking... stand by.

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

This seems like an obvious question, but I don't see that you mentioned the order of importing data. Are you importing the qty after you are importing the extension? That would trigger a recalculation of the extension and override what you import. If you are not importing the qty or the unit price, maybe Sage is looking at those and recalculating the extension from what was saved previously? You might try adding the qty and unit price prior to the extension so the last thing that happens is the extension.  

Allow Profit Margin Percent Override During S/O Data Entries is enabled.

Checking... stand by.

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

@David Overholt that is a good thought. If it was recalculating the extension it would fix itself. The extension right now does not foot. The bug I mentioned in the original post causes the extension to be incorrect. I am not importing the qty or unit price, just the extension, because I was thinking those are correct and do not need to be changed, only the extension is wrong so it does need to be imported. I will try importing the Qty Ordered, Qty Shipped, Qty Back Ordered & Unit Price along with the Extension and see what happens.

This seems like an obvious question, but I don't see that you mentioned the order of importing data. Are you importing the qty after you are importing the extension? That would trigger a recalculation of the extension and override what you import. If you are not importing the qty or the unit price, maybe Sage is looking at those and recalculating the extension from what was saved previously? You might try adding the qty and unit price prior to the extension so the last thing that happens is the extension.  

Allow Profit Margin Percent Override During S/O Data Entries is enabled.

Checking... stand by.

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...

Due to the bug, it might not sense that you are making a change... and not saving the record?  Perhaps import to ExtensionAmt to zero, then import the correct amounts?

@David Overholt that is a good thought. If it was recalculating the extension it would fix itself. The extension right now does not foot. The bug I mentioned in the original post causes the extension to be incorrect. I am not importing the qty or unit price, just the extension, because I was thinking those are correct and do not need to be changed, only the extension is wrong so it does need to be imported. I will try importing the Qty Ordered, Qty Shipped, Qty Back Ordered & Unit Price along with the Extension and see what happens.

This seems like an obvious question, but I don't see that you mentioned the order of importing data. Are you importing the qty after you are importing the extension? That would trigger a recalculation of the extension and override what you import. If you are not importing the qty or the unit price, maybe Sage is looking at those and recalculating the extension from what was saved previously? You might try adding the qty and unit price prior to the extension so the last thing that happens is the extension.  

Allow Profit Margin Percent Override During S/O Data Entries is enabled.

Checking... stand by.

All access?

@Kevin Moyes all lines are Misc Items (ItemType 5) and Allow Discount Rate by Detail Line box is unchecked in Sales Order Options.

I made sure there are no Perform Logic installed. Seems like it should be a no brainer, but there must be some logic check happening during the import.

UoM conversion factor <> 1?

Line Discount Percent <> 0?

@Kevin Moyes yes, I agree, but that doesn't seem to be the case.

I used the previous import I had used to import UnitPrice and replaced Extension for UnitPrice but it does not work. The strange thing is the import says all records are imported, but when I look at the records they have not been changed!?

If you can type it manually, you can import it.

@Beth Bowers I've done it before with a change to UnitPrice, so I assumed it would also work for Extension.

I would swear I've done that before.  I don't see why it would NOT work...