Menu
Welcome, Guest
Username: Password: Remember me

TOPIC: Flagging Taxable Items

Flagging Taxable Items 2 months 1 week ago #85826

  • jcrist
  • jcrist's Avatar
  • Offline
  • Elite Member
  • Posts: 226
  • Thank you received: 12
  • Karma: 1
Instead of flagging if a product has tax each time you add it to an invoice, is there no way to flag which products are taxable and which aren't and have it automatically add the tax based on that?
The administrator has disabled public write access.

Flagging Taxable Items 2 months 1 week ago #85851

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10664
  • Thank you received: 1603
  • Karma: 363
I don't think that feature exists, although I agree it makes sense and would be quite nice to have.

Seems like a simple customization, though - just add the field "Default tax" in "Products" module and use it in Line items edit view, if present.

This is easier to do in Core than to do as a custom development, and is of general interest, so I suggest that if you do it (or pay somebody to do it for you), add it as a core feature on Github.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.

Flagging Taxable Items 2 months 1 week ago #85853

  • cherub-chum
  • cherub-chum's Avatar
  • Offline
  • Elite Member
  • SuiteCRM Dev
  • Posts: 270
  • Thank you received: 49
  • Karma: 14
using a custom ⁨modules⁩/AOS_Products_Quotes⁩/lines_items.js file, and setting a custom field in each product to be either taxable or not, the functions in lines_items.js can handle this customisation.
Everything seems impossible, until its done.

Skype : cherubchum
The administrator has disabled public write access.

Flagging Taxable Items 2 months 4 days ago #85939

  • jcrist
  • jcrist's Avatar
  • Offline
  • Elite Member
  • Posts: 226
  • Thank you received: 12
  • Karma: 1
It looks like the Javascript only is loading field values from the AOS_Products table. Instead of adding a custom field to the AOS_Products_cstm table and then making the JS modification much more complicated, I was thinking of using the pre-existing 'maincode' field in the AOS_Products table which is a dropdown (product_code_dom) with values XXXX and YYYY so appears to not being used. I could change it to Yes/No for taxable status.

Or would it be easy for someone with advanced JS skills and knowledge of Sugar/Suite to pull the cstm values in from the JS code? I'm 100% sure I'd never need to actually use maincode field for a main product code designation (assuming that's what it does)
The administrator has disabled public write access.

Flagging Taxable Items 2 months 4 days ago #85941

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 10664
  • Thank you received: 1603
  • Karma: 363
I don't see much of a problem in using an existing field to avoid fetching cstm table.

It is also possible to add a custom field directly in the main table. The pros seem do some things differently from "standard" for other cases (relationships, for example)

As long as you know what you're doing and understand the consequences (is it upgrade-safe?), go ahead :)

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
Last Edit: 2 months 4 days ago by pgr.
The administrator has disabled public write access.

Flagging Taxable Items 2 months 3 days ago #85969

  • jcrist
  • jcrist's Avatar
  • Offline
  • Elite Member
  • Posts: 226
  • Thank you received: 12
  • Karma: 1
Yes I noticed a Quickbooks module I loaded and removed a long time ago the fields from the module with _c in the field name are still in the main table, so you must be correct in that I could manually add fields to the main table myself as all insert statements in Suite mus have corresponding field names I assume so there is no field count mismatch on an insert.
The administrator has disabled public write access.
Time to create page: 0.060 seconds
Powered by Kunena Forum