Actinic Link to Quickbooks Translation Table

[PeterThake]

Hi,

Help!!! I am stuck! I am upgrading to v8 and am keen to use LINK. But I have many products in Actinic which reference the same single entries in Quickbooks (QB). ie a many to one relationship.

For example, a Freehand yoyo is available in 8 colours. So in Actinic I have 8 products: one for each colour. Freehand red, Freehand green etc. In Quickbooks I have one Item. Freehand. I do not record items down to the colour level in QB.

When I create a Link Translation table I get this type of error:

This value: 'Aerobie: Dogobie disc' is found more than once in the 'QuickBooks Reference' column, in the Translation table.

I do not want to use Attributes with colour choices because my customers like to be able to see each colour. Plus this would mean a major rework of my site! I prefer to list each colour as a distinct item.

I cannot use product duplicates since I think I cannot set separate stock levels for the duplicates.

The only way round this I can see at the moment is to create a separate stock item in Quickbooks for each colour for each yoyo. This would quadruple an already large QB inventory!

Is there any way to allow duplicate entries for Quickbooks references in the LINK translation table?

Any help greatly appreciated since I am beginning to wonder if I have made a mistake with deciding to upgrade...

Thanks in anticipation,
Pete

[PeterThake]

Bump

Shameless bump! This is driving me mad. Why else would I be sat at my PC on a Saturday morning at 6am!

[Bruce]

Peter,

Sorry this has not been answered as yet. I am not at a system that has QB on it at the moment, but will check this for you tomorrow.

Kind regards,

[PeterThake]

Translation table

Thanks Bruce. BTW it is not neccessary to have QB to test this. It throws up the error long before you reach QB. Just try importing a translation table using LINK with duplicates in the QB field to replicate the error. eg.

Actinic unique field <===> QB field
------------------------------------------------
Green Yoyo <===> Yoyo
Red yoyo <===> Yoyo

If it is not possible could it be added to the wish list?

Cheers,
Pete

[Bruce]

I know that, but I dont have link on my home PC either, did not see the need for it here... Will check this and update you in the morning.

[PeterThake]

No Link

Sorry Bruce!

[Bruce]

Peter,

This is to give you an update. I have not been able to do this using link to QB, keep getting the error you get about it already being available. I have passed this to development to comment on and will update you as soon as I hear back from them.

Kind regards,

[PeterThake]

Many thanks

Thanks Bruce, I look forward to an update
Pete

[Bruce]

Peter,

This cannot be done. The translation table does not support duplicate entries so it is not possible to map multiple ProductID's to one in QB. I will add this on to the wish list for you.

Kind regards,

[PeterThake]

Thanks!

Thanks Bruce.

[domino1]

Hi All.
The issue I have is the opposite to Peter's issue above. I have products in Actinic that have size attirbutes. eg:

Jacket - Size 1
Jacket - Size 2
Jacket - Size 3

In Actinic this is one product so only has a single reference.

In Quickbooks this is listed as three products, one for each size. It has to be done this way for stock control reasons.

Can Actinic Link be configured to map the different sizes to individual product codes? eg:

Jacket Size 1 mapped to Product code J001
Jacket Size 2 mapped to product code J002
Jacket Size 3 mapped to product code J003

Many Thanks

Dave

EDIT: (Started new thread in V8 - General)
http://community.actinic.com/showthread.php?t=32786

[Bruce]

For anyone else coming along, the solution for the issue is on the new thread Dave started @ http://community.actinic.com/showthread.php?t=32786

Kind regards,